﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPages/SiteMaster.master" AutoEventWireup="true" CodeBehind="Imoveis.aspx.cs" Inherits="PRJ_LDW_Eutoliso.Public.Imoveis" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" runat="server">
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="headScript" runat="server">
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="header_search" runat="server">
</asp:Content>
<asp:Content ID="Content4" ContentPlaceHolderID="login_header" runat="server">
</asp:Content>
<asp:Content ID="Content5" ContentPlaceHolderID="header_pos_menu" runat="server">
</asp:Content>
<asp:Content ID="Content6" ContentPlaceHolderID="body_pre_central" runat="server">
</asp:Content>
<asp:Content ID="Content7" ContentPlaceHolderID="body_central" runat="server">


    <!-- Start H1 Title -->
    <div class="titlesnormal">

        <h1>Anuncios de Imóveis</h1>



    </div>
    <!-- End H1 Title -->
    <!-- Start Main Body Wrap -->
    <div id="main-wrap">

        <!-- Start Left Section -->
        <div class="leftsection">


            <asp:GridView ID="gdvImoveis" runat="server" AutoGenerateColumns="False" DataSourceID="sqlImoveis" CellPadding="0" GridLines="None" AllowPaging="True">
                <Columns>
                    <asp:TemplateField>
                        <ItemTemplate>
                            <itemtemplate>
                                <div class="blogwrap">
                                    <div class="blogtitle">
                                        <h3><a href="#" title="">
                                            <asp:Label ID="lbltitulo" runat="server" Text='<%# Eval("TituloVenda") %>'></asp:Label>
                                            </a></h3>
                                    </div>
                                    <div class="blogbody">
                                        <!-- Start Blog Image -->
                                        <div class="blogimage">
                                            <asp:Image ID="Image1" runat="server" Height="230px" ImageUrl='<%# Eval("Imagem") %>' />
                                        </div>
                                        <!-- End Blog Text -->
                                        <!-- Start Blog Information -->
                                        <div class="bloginfo">
                                            <%--<p class="usericon">
                                            Postado por: <span>
                                                <asp:Label ID="lblUser" runat="server" Text='<%# Eval("Usuarios") %>'></asp:Label></span></p>--%>
                                            <p class="calendericon">
                                                Anunciado em: <span>
                                                <asp:Label ID="lblData" runat="server" Text='<%# Eval("Dataanuncio" , "{0:d}") %>'></asp:Label>
                                                </span>
                                            </p>
                                           
                                           
                                            <p class="tagicon">
                                                Valor: <span><asp:Label ID="lblValor" runat="server" Text='<%# Eval("Valor") %>'></asp:Label></span>

                                            </p>

                                             <p class="homeicon">
                                            Local: <span>
                                                <asp:Label ID="lblCidade" runat="server" Text='<%# Eval("Cidade") %>'></asp:Label>, <asp:Label ID="lblEstado" runat="server" Text='<%# Eval("Uf") %>'></asp:Label></span></p>

                                             <p class="settingsicon">
                                                Categoria: <span>
                                                <asp:Label ID="lblCategoria" runat="server" Text='<%# Eval("Categoria") %>'></asp:Label>
                                                </span>
                                            </p>

                                            <p class="settingsicon">
                                                Situação: <span><asp:Label ID="Label5" runat="server" Text='<%# Eval("Estadositaacao") %>'></asp:Label></span>

                                            </p>
                                           

                                            <p class="settingsicon">
                                                Área: <span>
                                                <asp:Label ID="Label1" runat="server" Text='<%# Eval("Area") %>'></asp:Label> m²
                                                </span>
                                            </p>

                                            <p class="settingsicon">
                                                Nº de Salas: <span>
                                                <asp:Label ID="Label2" runat="server" Text='<%# Eval("Sala") %>'></asp:Label>
                                                </span>
                                            </p>

                                            <p class="settingsicon">
                                                Nº de Quartos: <span>
                                                <asp:Label ID="Label3" runat="server" Text='<%# Eval("Quantquartos") %>'></asp:Label>
                                                </span>
                                            </p>

                                           

                                        </div>
                                        <!-- End Blog Information -->
                                        <!-- Start Blog Text -->
                                       
                                        <div class="blogtext">
                                             <%--<br />--%>
                                            <p>
                                                <asp:Label ID="lblDescricao" runat="server" Text='<%# Eval("DescGeral") %>'></asp:Label>
                                            </p>
                                            <p class="blogbutton">
                                                <a class="smallsmoothrectange orangebutton" href="#" title="">Mais Informações</a></p>
                                        </div>
                                        <!-- End Blog Text -->
                                    </div>
                                </div>
                            </itemtemplate>
                        </ItemTemplate>
                    </asp:TemplateField>

                </Columns>
            </asp:GridView>



            <div class="blogwrap">

                <div class="blogpagination">

                  <%--  <ul>
                        <li><a href="#" title="Start" class="normal">Start</a></li>
                        <li><a href="#" title="Previous" class="normal">&lt;Prev</a></li>
                        <li><a href="#" title="1" class="normal">1</a></li>
                        <li><a href="#" title="2" class="normal">2</a></li>
                        <li><a href="#" title="3" class="normal">3</a></li>
                        <li><a href="#" title="4" class="normal">4</a></li>
                        <li><a href="#" title="5" class="normalactive">5</a></li>
                        <li><a href="#" title="6" class="normal">6</a></li>
                        <li><a href="#" title="7" class="normal">7</a></li>
                        <li><a href="#" title="8" class="normal">8</a></li>
                        <li><a href="#" title="9" class="normal">9</a></li>
                        <li><a href="#" title="10" class="normal">10</a></li>
                        <li><a href="#" title="Next" class="normal">Next&gt;</a></li>
                        <li><a href="#" title="Last" class="normal">Last</a></li>
                    </ul>--%>

                </div>


            </div>
            <!-- End Pagination -->

        </div>
        <!-- End Left Section -->

        <!-- Start Right Section -->
        <div class="rightsection">

            <!-- Start Blog Widget -->
            <br />
            <br />
            <br />
            <div class="blogwidgetstart">
                <!-- Start Advertising Widget -->

                <div class="widgettitle">
                    <h4>Publicidade</h4>
                </div>

                <div class="widgetbody">

                    <div class="blogadvertising">

                        <a href="#">
                            <img src="/App_Themes/eutoliso/images/advertising/themeadvertising.jpg" alt="Themeforest" /></a>
                        <a href="#">
                            <img src="/App_Themes/eutoliso/images/advertising/audioadvertising.jpg" alt="Audiojungle" /></a>
                        <a href="#">
                            <img src="/App_Themes/eutoliso/images/advertising/graphicadvertising.jpg" alt="Grahpicrive" /></a>
                        <a href="#">
                            <img src="/App_Themes/eutoliso/images/advertising/tutorialadvertising.jpg" alt="Tutsplus" /></a>

                    </div>

                </div>
                <!-- End Advertising Widget -->


            </div>
            <!-- End Blog Widget -->

            <!-- Start Blog Widget -->
            <div class="blogwidget">
                <!-- Start Categories Widget -->
                <div class="widgettitle">
                    <h4>Categorias</h4>
                </div>

                <div class="widgetbody">

                    <div class="blogcategories">

                        <ul>

                            <li><a href="#" title="All Blogs">Convívios</a></li>
                            <li><a href="#" title="All Blogs">Festas</a></li>
                            <li><a href="#" title="All Blogs">Discotecas</a></li>
                            <li><a href="#" title="All Blogs">Redes Sociais</a></li>
                            <li><a href="#" title="All Blogs">Todas as Categorias</a></li>
                        </ul>

                    </div>

                </div>
                <!-- End Categories Widget -->


            </div>
            <!-- End Blog Widget -->

            <!-- Start Blog Widget -->
            <div class="blogwidget">
                <!-- Start Categories Widget -->
                <div class="widgettitle">
                    <h4>Links Institucionais</h4>
                </div>

                <div class="widgetbody">

                    <div class="blogcategories">

                        <ul>
                            <li><a href="#" title="All Blogs">Câmera Municipal de Coimbra</a></li>
                            <li><a href="#" title="All Blogs">SEF - Serviços de Estrangeiros</a></li>
                        </ul>

                    </div>

                </div>
                <!-- End Categories Widget -->


            </div>
            <!-- End Blog Widget -->

        </div>
        <!-- End Right Section -->

    </div>
    <!-- End Main Body Wrap -->


    <asp:SqlDataSource ID="sqlImoveis" runat="server" ConnectionString="<%$ ConnectionStrings:eutolisodbConnectionString %>" SelectCommand="SELECT cidade.Nome AS Cidade, estado.Nome AS Estado, estado.Regiao, estado.Uf, imoveltipo.Nome AS Categoria, imovel.TituloVenda, imovel.Quantquartos, imovel.Posicaosolar, imovel.Garagem, imovel.Estadositaacao, imovel.Area, imovel.Andar, imovel.Sala, imovel.Suite, imovel.Adicionais, imovel.Valor, imovel.Vistas, imovel.Descgeral, imovel.Descinterior, imovel.Dataanuncio, imovel.Imagem, imovel.Imagem_02, imovel.Imagem_03, imovel.Imagem_04, imovel.Usuario FROM cidade INNER JOIN estado ON cidade.Estado = estado.Id INNER JOIN imovel ON cidade.Id = imovel.Cidade INNER JOIN imoveltipo ON imovel.Tipo = imoveltipo.Id

ORDER BY imovel.Dataanuncio DESC"></asp:SqlDataSource>

</asp:Content>
<asp:Content ID="Content8" ContentPlaceHolderID="body_pos_central" runat="server">
</asp:Content>
<asp:Content ID="Content9" ContentPlaceHolderID="body_pos_a_central" runat="server">
</asp:Content>
<asp:Content ID="Content10" ContentPlaceHolderID="footer_twitter_realtime" runat="server">
</asp:Content>
<asp:Content ID="Content11" ContentPlaceHolderID="footer_search" runat="server">
</asp:Content>
<asp:Content ID="Content12" ContentPlaceHolderID="ContentPlaceHolder1" runat="server">
</asp:Content>
